home *** CD-ROM | disk | FTP | other *** search
/ PC Basics 53 / PC Basics Issue 53.iso / Software / Internet / Invboard.exe / PC Basics 53 / Invboard / upload / sources / Admin / ad_member.php < prev    next >
Encoding:
PHP Script  |  2002-08-01  |  47.3 KB  |  1,583 lines
  1. <?php
  2.  
  3. /*
  4. +--------------------------------------------------------------------------
  5. |   IBFORUMS v1
  6. |   ========================================
  7. |   by Matthew Mecham and David Baxter
  8. |   (c) 2001,2002 IBForums
  9. |   http://www.ibforums.com
  10. |   ========================================
  11. |   Web: http://www.ibforums.com
  12. |   Email: phpboards@ibforums.com
  13. |   Licence Info: phpib-licence@ibforums.com
  14. +---------------------------------------------------------------------------
  15. |
  16. |   > Admin Forum functions
  17. |   > Module written by Matt Mecham
  18. |   > Date started: 1st march 2002
  19. |
  20. |    > Module Version Number: 1.0.0
  21. +--------------------------------------------------------------------------
  22. */
  23.  
  24.  
  25. $idx = new ad_forums();
  26.  
  27.  
  28. class ad_forums {
  29.  
  30.     var $base_url;
  31.  
  32.     function ad_forums() {
  33.         global $IN, $root_path, $INFO, $DB, $SKIN, $ADMIN, $std, $MEMBER, $GROUP, $ibforums;
  34.  
  35.         switch($IN['code'])
  36.         {
  37.             case 'stepone':
  38.                 $this->step_one();
  39.                 break;
  40.             case 'doform':
  41.                 $this->do_edit_form();
  42.                 break;
  43.             case 'doedit':
  44.                 $this->do_edit();
  45.                 break;
  46.             //---------------------
  47.             case 'add':
  48.                 $this->add_form();
  49.                 break;
  50.             case 'doadd':
  51.                 $this->do_add();
  52.                 break;
  53.             //---------------------
  54.             case 'del':
  55.                 $this->delete_form();
  56.                 break;
  57.             case 'delete2':
  58.                 $this->delete_lookup_form();
  59.                 break;
  60.             case 'dodelete':
  61.                 $this->dodelete();
  62.                 break;
  63.             case 'prune':
  64.                 $this->prune_confirm();
  65.                 break;
  66.             case 'doprune':
  67.                 $this->doprune();
  68.                 break;
  69.             //---------------------
  70.             case 'title':
  71.                 $this->titles();
  72.                 break;
  73.             case 'rank_edit':
  74.                 $this->rank_setup('edit');
  75.                 break;
  76.             case 'rank_add':
  77.                 $this->rank_setup('add');
  78.                 break;
  79.             case 'do_add_rank':
  80.                 $this->add_rank();
  81.                 break;
  82.             case 'do_rank_edit':
  83.                 $this->edit_rank();
  84.                 break;
  85.             case 'rank_delete':
  86.                 $this->delete_rank();
  87.                 break;
  88.             //---------------------
  89.             case 'ban':
  90.                 $this->ban_control();
  91.                 break;
  92.             case 'doban':
  93.                 $this->update_ban();
  94.                 break;
  95.             //---------------------
  96.             case 'mod':
  97.                 $this->view_mod();
  98.                 break;
  99.             case 'domod':
  100.                 $this->domod();
  101.                 break;
  102.             //---------------------    
  103.             default:
  104.                 $this->search_form();
  105.                 break;
  106.         }
  107.         
  108.     }
  109.     
  110.     
  111.     
  112.     //+---------------------------------------------------------------------------------
  113.     //
  114.     // Moderation control...
  115.     //
  116.     //+---------------------------------------------------------------------------------
  117.     
  118.     function domod() {
  119.         global $IN, $root_path, $INFO, $DB, $SKIN, $ADMIN, $std, $MEMBER, $GROUP;
  120.         
  121.         $ids = array();
  122.         
  123.         foreach ($IN as $k => $v)
  124.         {
  125.             if ( preg_match( "/^mid_(\d+)$/", $k, $match ) )
  126.             {
  127.                 if ($IN[ $match[0] ])
  128.                 {
  129.                     $ids[] = $match[1];
  130.                 }
  131.             }
  132.         }
  133.         
  134.         //-------------------
  135.         
  136.         if ( count($ids) < 1 )
  137.         {
  138.             $ADMIN->error("You did not select any members to approve or delete");
  139.         }
  140.         
  141.         
  142.         
  143.         //-------------------
  144.         
  145.         if ($IN['type'] == 'approve')
  146.         {
  147.         
  148.             //-------------------------------------------
  149.             
  150.             require $root_path."sources/lib/emailer.php";
  151.             
  152.             $email = new emailer();
  153.             
  154.             $email->get_template("complete_reg");
  155.             
  156.             $email->build_message( "" );
  157.             
  158.             $email->subject = "Account validated at ".$INFO['board_name'];
  159.             
  160.             //-------------------------------------------
  161.             
  162.             $main = $DB->query("SELECT id, email, validate_key, mgroup, prev_group FROM ibf_members WHERE id IN(".implode( ",",$ids ).")");
  163.             
  164.             while( $row = $DB->fetch_row( $main ) )
  165.             {
  166.                 if ($row['mgroup'] != $INFO['auth_group'])
  167.                 {
  168.                     continue;
  169.                 }
  170.                 
  171.                 if ($row['prev_group'] == "")
  172.                 {
  173.                     $row['prev_group'] = $INFO['member_group'];
  174.                 }
  175.                 
  176.                 $update = $DB->query("UPDATE ibf_members SET prev_group='', validate_key='', mgroup='".$row['prev_group']."' WHERE id='".$row['id']."'");
  177.                 
  178.                 $email->to = $row['email'];
  179.                 
  180.                 $email->send_mail();
  181.             }
  182.             
  183.             $DB->query("SELECT id, name FROM ibf_members WHERE mgroup <> '".$INFO['auth_group']."' ORDER BY id DESC LIMIT 0,1");
  184.             $r = $DB->fetch_row();
  185.  
  186.             $DB->query("UPDATE ibf_stats SET MEM_COUNT=MEM_COUNT+".count($ids).", LAST_MEM_NAME='{$r['name']}', LAST_MEM_ID='{$r['id']}'");
  187.             
  188.             
  189.             $ADMIN->done_screen( count($ids)." Members Approved", "Manage Registrations", "act=mem&code=mod" );    
  190.             
  191.         }
  192.         else
  193.         {
  194.             $DB->query("DELETE FROM ibf_members WHERE id IN(".implode( ",",$ids ).")");
  195.             
  196.             $DB->query("UPDATE ibf_stats SET MEM_COUNT=MEM_COUNT-".count($ids));
  197.             
  198.             $ADMIN->done_screen( count($ids)." Members Removed", "Manage Registrations", "act=mem&code=mod" );
  199.         }
  200.         
  201.     }
  202.     
  203.     
  204.     //---------------------------------------------
  205.     
  206.     function view_mod() {
  207.         global $IN, $root_path, $INFO, $DB, $SKIN, $ADMIN, $std, $MEMBER, $GROUP;
  208.         
  209.         $ADMIN->page_title  = "Manage User Registration/Email Change Queues";
  210.         
  211.         $ADMIN->page_detail = "This section allows you to allow or deny registrations where you have requested that an administrator previews new accounts before allowing full membership. It will also allow you to complete or deny new email address changes.<br><br>This form will also allow you to complete the registrations for those who did not receive an email.";
  212.         
  213.         $DB->query("SELECT COUNT(id) as mcount FROM ibf_members WHERE mgroup='".$INFO['auth_group']."' and (new_pass = '' or new_pass is null)");
  214.         
  215.         $row = $DB->fetch_row();
  216.         
  217.         $cnt = $row['mcount'] < 1 ? 0 : $row['mcount'];
  218.         
  219.         $ADMIN->html .= $SKIN->start_form( array( 1 => array( 'code'  , 'domod'  ),
  220.                                                   2 => array( 'act'   , 'mem'    ),
  221.                                          )      );
  222.                                          
  223.         $SKIN->td_header[] = array( "Member Name"       , "30%" );
  224.         $SKIN->td_header[] = array( "Email Address"     , "30%" );
  225.         $SKIN->td_header[] = array( "Posts"             , "10%" );
  226.         $SKIN->td_header[] = array( "Registered On"     , "20%" );
  227.         $SKIN->td_header[] = array( "Select"            , "10%" );
  228.         
  229.         $ADMIN->html .= $SKIN->start_table( "Users awaiting authorisation" );
  230.         
  231.         $ADMIN->html .= $SKIN->add_td_basic( "<b>$cnt users require registration or email change validation, showing 0 - 75</b>", "center", "title");
  232.         
  233.         if ($cnt > 0)
  234.         {
  235.             $DB->query("SELECT name, id, email, posts, joined FROM ibf_members WHERE mgroup='".$INFO['auth_group']."' and (new_pass = '' or new_pass is null) ORDER BY joined DESC LIMIT 0,75");
  236.             
  237.             while ( $r = $DB->fetch_row() )
  238.             {
  239.                 $ADMIN->html .= $SKIN->add_td_row( array( "<b>".$r['name']."</b>" ,
  240.                                                             $r['email'],
  241.                                                             "<center>{$r['posts']}</center>",
  242.                                                             $std->get_date( $r['joined'], 'JOINED' ),
  243.                                                             "<input type='checkbox' name='mid_{$r['id']}' value='1'>"
  244.                                              )      );
  245.             }
  246.             
  247.             $ADMIN->html .= $SKIN->add_td_basic("<select name='type' id='dropdown'><option value='approve'>Approve these Accounts</option><option value='delete'>DELETE these accounts</option></select>", "center", "row1" );
  248.             
  249.         }
  250.         
  251.         $ADMIN->html .= $SKIN->end_form("Go!");
  252.                                          
  253.         $ADMIN->html .= $SKIN->end_table();
  254.         
  255.         $ADMIN->output();
  256.         
  257.     }
  258.     
  259.     
  260.     
  261.     //+---------------------------------------------------------------------------------
  262.     //
  263.     // Ban control...
  264.     //
  265.     //+---------------------------------------------------------------------------------
  266.     
  267.     function ban_control() {
  268.         global $IN, $root_path, $INFO, $DB, $SKIN, $ADMIN, $std, $MEMBER, $GROUP;
  269.         
  270.         $ADMIN->page_title = "Ban Control";
  271.         
  272.         $ADMIN->page_detail = "This section allows you to modify, delete or add IP addresses, email addresses and reserved names to the ban filters.";
  273.         
  274.         $ADMIN->html .= $SKIN->start_form( array( 1 => array( 'code'  , 'doban'  ),
  275.                                                   2 => array( 'act'   , 'mem'       ),
  276.                                          )      );
  277.                                          
  278.         $ip_list    = "";
  279.         $name_list  = "";
  280.         $email_list = "";
  281.         
  282.         if ($INFO['ban_ip'] != "")
  283.         {
  284.             $ip_list = preg_replace( "/\|/", "\n", $INFO['ban_ip'] );
  285.         }
  286.         
  287.         //+-------------------------------
  288.         
  289.         if ($INFO['ban_email'] != "")
  290.         {
  291.             $email_list = preg_replace( "/\|/", "\n", $INFO['ban_email'] );
  292.         }
  293.         
  294.         //+-------------------------------
  295.         
  296.         if ($INFO['ban_names'] != "")
  297.         {
  298.             $name_list = preg_replace( "/\|/", "\n", $INFO['ban_names'] );
  299.         }
  300.  
  301.         //+-------------------------------
  302.         
  303.         $SKIN->td_header[] = array( " "     , "40%" );
  304.         $SKIN->td_header[] = array( " "     , "60%" );
  305.         
  306.         //+-------------------------------
  307.         
  308.         $ADMIN->html .= $SKIN->start_table( "Ban Control" );
  309.         
  310.         $ADMIN->html .= $SKIN->add_td_basic("Banned IP Addresses (one per line - use * as a wildcard)", "center", "title");
  311.         
  312.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>Banned IP Address</b><br>(Example: 212.45.45.23)<br>(Example: 212.45.45.*)" ,
  313.                                                   $SKIN->form_textarea( 'ban_ip', $ip_list )
  314.                                              )      );
  315.                                              
  316.         $ADMIN->html .= $SKIN->add_td_basic("Banned Email Addresses (one per line - use * as a wildcard)", "center", "title");
  317.         
  318.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>Banned Email Address</b><br>(Example: name@domain.com)<br>(Example: *@domain.com)" ,
  319.                                                   $SKIN->form_textarea( 'ban_email', $email_list )
  320.                                              )      );
  321.                                              
  322.         $ADMIN->html .= $SKIN->add_td_basic("Banned / Reserved Names (one per line)", "center", "title");
  323.         
  324.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>Banned Names</b>" ,
  325.                                                   $SKIN->form_textarea( 'ban_names', $name_list )
  326.                                              )      );
  327.                                              
  328.         $ADMIN->html .= $SKIN->end_form("Update the ban filters");
  329.                                          
  330.         $ADMIN->html .= $SKIN->end_table();
  331.         
  332.         $ADMIN->output();
  333.  
  334.     }
  335.     
  336.     function update_ban() {
  337.         global $IN, $root_path, $INFO, $DB, $SKIN, $ADMIN, $std, $MEMBER, $GROUP, $HTTP_POST_VARS;
  338.         
  339.         // Get the incoming..
  340.         
  341.         $new = array();
  342.         
  343.         $new['ban_ip']    = preg_replace( "/\n/", "|", trim($HTTP_POST_VARS['ban_ip'])     );
  344.         $new['ban_email'] = preg_replace( "/\n/", "|", trim($HTTP_POST_VARS['ban_email'])  );
  345.         $new['ban_names'] = preg_replace( "/\n/", "|", trim($HTTP_POST_VARS['ban_names'])  );
  346.         
  347.         $ADMIN->rebuild_config( $new );
  348.         
  349.         $ADMIN->done_screen("Ban Filters Updated", "Ban Control", "act=mem&code=ban" );        
  350.         
  351.     }
  352.         
  353.         
  354.         
  355.     //+---------------------------------------------------------------------------------
  356.     //
  357.     // MEMBER RANKS...
  358.     //
  359.     //+---------------------------------------------------------------------------------
  360.     
  361.     function titles() {
  362.         global $IN, $root_path, $INFO, $DB, $SKIN, $ADMIN, $std, $MEMBER, $GROUP;
  363.         
  364.         $ADMIN->page_title = "Member Ranking Set Up";
  365.         
  366.         $ADMIN->page_detail = "This section allows you to modify, delete or add extra ranks.<br>If you wish to display pips below the members name, enter the number of pips. If you wish to use a custom image, simply enter the image name in the pips box. Note, these custom images must reside in the 'html/team_icons' directory of your installation";
  367.         
  368.         
  369.         //+-------------------------------
  370.         
  371.         $SKIN->td_header[] = array( "Title"      , "30%" );
  372.         $SKIN->td_header[] = array( "Min Posts"  , "10%" );
  373.         $SKIN->td_header[] = array( "Pips"       , "20%" );
  374.         $SKIN->td_header[] = array( " "     , "20%" );
  375.         $SKIN->td_header[] = array( " "     , "20%" );
  376.         
  377.         //+-------------------------------
  378.         
  379.         $DB->query("SELECT s.*, i.*, t.template FROM ibf_templates t, ibf_skins s, ibf_images i ".
  380.                    "WHERE s.default_set=1 AND t.tmid=s.tmpl_id AND i.imid=s.img_id");
  381.                    
  382.         $row = $DB->fetch_row();
  383.         
  384.         $ADMIN->html .= $SKIN->start_table( "Member Titles/Ranks" );
  385.         
  386.         $DB->query("SELECT * FROM ibf_titles ORDER BY posts");
  387.         
  388.         while ( $r = $DB->fetch_row() )
  389.         {
  390.             $img = "";
  391.             
  392.             if ( preg_match( "/^\d+$/", $r['pips'] ) )
  393.             {
  394.                 for ($i = 1; $i <= $r['pips']; $i++)
  395.                 {
  396.                     $img .= $row['A_STAR'];
  397.                     
  398.                 }
  399.             }
  400.             else
  401.             {
  402.                 $img = "<img src='html/team_icons/{$r['pips']}' border='0'>";
  403.             }
  404.                 
  405.             $ADMIN->html .= $SKIN->add_td_row( array( "<b>".$r['title']."</b>" ,
  406.                                                       $r['posts'],
  407.                                                       $img,
  408.                                                       "<a href='{$SKIN->base_url}&act=mem&code=rank_edit&id={$r['id']}'>Edit</a>",
  409.                                                       "<a href='{$SKIN->base_url}&act=mem&code=rank_delete&id={$r['id']}'>Delete</a>",
  410.                                              )      );
  411.             
  412.         }
  413.                                          
  414.         
  415.                                          
  416.         $ADMIN->html .= $SKIN->end_table();
  417.         
  418.         //+-------------------------------
  419.         
  420.         $ADMIN->html .= $SKIN->start_form( array( 1 => array( 'code'  , 'do_add_rank'  ),
  421.                                                   2 => array( 'act'   , 'mem'       ),
  422.                                          )      );
  423.         
  424.         //+-------------------------------
  425.         
  426.         $SKIN->td_header[] = array( " "  , "40%" );
  427.         $SKIN->td_header[] = array( " "  , "60%" );
  428.         
  429.         //+-------------------------------
  430.         
  431.         $ADMIN->html .= $SKIN->start_table( "Add a Member Rank" );
  432.         
  433.                                          
  434.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>Rank Title</b>" ,
  435.                                                   $SKIN->form_input( "title" )
  436.                                          )      );
  437.                                          
  438.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>Minimum number of posts needed</b>" ,
  439.                                                   $SKIN->form_input( "posts" )
  440.                                          )      );
  441.  
  442.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>Number of pips</b><br>(Or pip image)" ,
  443.                                                   $SKIN->form_input( "pips" )
  444.                                          )      );
  445.                                                                                   
  446.         $ADMIN->html .= $SKIN->end_form("Add this rank");
  447.                                          
  448.         $ADMIN->html .= $SKIN->end_table();
  449.         
  450.         $ADMIN->output();
  451.     }
  452.     
  453.     //+---------------------------------------------------------------------------------
  454.     
  455.     function add_rank() {
  456.         global $IN, $root_path, $INFO, $DB, $SKIN, $ADMIN, $std, $MEMBER, $GROUP;
  457.         
  458.         //+-------------------------------
  459.         // check for input
  460.         //+-------------------------------
  461.         
  462.         foreach( array( 'posts', 'title', 'pips' ) as $field )
  463.         {
  464.             if ($IN[ $field ] == "")
  465.             {
  466.                 $ADMIN->error("You must complete the form fully");
  467.             }
  468.         }
  469.         
  470.         //+-------------------------------
  471.         // Add it to the DB
  472.         //+-------------------------------
  473.         
  474.         $db_string = $DB->compile_db_insert_string( array (
  475.                                                              'posts'  => trim($IN['posts']),
  476.                                                              'title'  => trim($IN['title']),
  477.                                                              'pips'   => trim($IN['pips']),
  478.                                                   )       );
  479.                                                   
  480.         $DB->query("INSERT INTO ibf_titles (" .$db_string['FIELD_NAMES']. ") VALUES (". $db_string['FIELD_VALUES'] .")");
  481.         
  482.         $ADMIN->done_screen("Rank Added", "Member Ranking Control", "act=mem&code=title" );                    
  483.         
  484.         
  485.     }
  486.     
  487.     //+---------------------------------------------------------------------------------
  488.     
  489.     function delete_rank() {
  490.         global $IN, $root_path, $INFO, $DB, $SKIN, $ADMIN, $std, $MEMBER, $GROUP;
  491.         
  492.         //+-------------------------------
  493.         // check for input
  494.         //+-------------------------------
  495.         
  496.         if ($IN['id'] == "")
  497.         {
  498.             $ADMIN->error("We could not match that ID");
  499.         }
  500.         
  501.         $DB->query("DELETE FROM ibf_titles WHERE id='".$IN['id']."'");
  502.         
  503.         $ADMIN->done_screen("Rank Removed", "Member Ranking Control", "act=mem&code=title" );
  504.         
  505.     }
  506.     
  507.     //+---------------------------------------------------------------------------------
  508.     
  509.     function edit_rank() {
  510.         global $IN, $root_path, $INFO, $DB, $SKIN, $ADMIN, $std, $MEMBER, $GROUP;
  511.         
  512.         //+-------------------------------
  513.         // check for input
  514.         //+-------------------------------
  515.         
  516.         if ($IN['id'] == "")
  517.         {
  518.             $ADMIN->error("We could not match that ID");
  519.         }
  520.         
  521.         //+-------------------------------
  522.         
  523.         foreach( array( 'posts', 'title', 'pips' ) as $field )
  524.         {
  525.             if ($IN[ $field ] == "")
  526.             {
  527.                 $ADMIN->error("You must complete the form fully");
  528.             }
  529.         }
  530.         
  531.         //+-------------------------------
  532.         // Add it to the DB
  533.         //+-------------------------------
  534.         
  535.         $db_string = $DB->compile_db_update_string( array (
  536.                                                              'posts'  => trim($IN['posts']),
  537.                                                              'title'  => trim($IN['title']),
  538.                                                              'pips'   => trim($IN['pips']),
  539.                                                   )       );
  540.                                                   
  541.         $DB->query("UPDATE ibf_titles SET $db_string WHERE id='".$IN['id']."'");
  542.         
  543.         $ADMIN->done_screen("Rank Edited", "Member Ranking Control", "act=mem&code=title" );                    
  544.         
  545.         
  546.     }
  547.     
  548.     //+---------------------------------------------------------------------------------
  549.     
  550.     function rank_setup($mode='edit') {
  551.         global $IN, $root_path, $INFO, $DB, $SKIN, $ADMIN, $std, $MEMBER, $GROUP;
  552.         
  553.         $ADMIN->page_title = "Member Rank Set Up";
  554.         
  555.         $ADMIN->page_detail = "If you wish to display pips below the members name, enter the number of pips. If you wish to use a custom image, simply enter the image name in the pips box. Note, these custom images must reside in the 'html/team_icons' directory of your installation";
  556.         
  557.         if ($mode == 'edit')
  558.         {
  559.             $form_code = 'do_rank_edit';
  560.             
  561.             if ($IN['id'] == "")
  562.             {
  563.                 $ADMIN->error("No rank ID was set, please try again");
  564.             }
  565.             
  566.             $DB->query("SELECT * from ibf_titles WHERE id='".$IN['id']."'");
  567.             $rank = $DB->fetch_row();
  568.             
  569.             $button = "Complete Edit";
  570.         }
  571.         else
  572.         {
  573.             $form_code = 'do_add_rank';
  574.             $rank = array( 'posts' => "", 'title' => "", 'pips' => "");
  575.             $button = "Add this rank";
  576.         }
  577.         
  578.         //+-------------------------------
  579.         
  580.         $ADMIN->html .= $SKIN->start_form( array( 1 => array( 'code'  , $form_code  ),
  581.                                                   2 => array( 'act'   , 'mem'       ),
  582.                                                   3 => array( 'id'    , $rank['id'] ),
  583.                                          )      );
  584.         
  585.         //+-------------------------------
  586.         
  587.         $SKIN->td_header[] = array( " "  , "40%" );
  588.         $SKIN->td_header[] = array( " "  , "60%" );
  589.         
  590.         //+-------------------------------
  591.         
  592.         $ADMIN->html .= $SKIN->start_table( "Member Ranks" );
  593.         
  594.                                          
  595.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>Rank Title</b>" ,
  596.                                                   $SKIN->form_input( "title", $rank['title'] )
  597.                                          )      );
  598.                                          
  599.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>Minimum number of posts needed</b>" ,
  600.                                                   $SKIN->form_input( "posts", $rank['posts'] )
  601.                                          )      );
  602.  
  603.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>Number of pips</b><br>(Or pip image)" ,
  604.                                                   $SKIN->form_input( "pips", $rank['pips'] )
  605.                                          )      );
  606.                                                                                   
  607.         $ADMIN->html .= $SKIN->end_form($button);
  608.                                          
  609.         $ADMIN->html .= $SKIN->end_table();
  610.         
  611.         $ADMIN->output();
  612.         
  613.         
  614.     }
  615.     
  616.     //+---------------------------------------------------------------------------------
  617.     
  618.     
  619.     //+---------------------------------------------------------------------------------
  620.     //
  621.     // DELETE MEMBER SET UP
  622.     //
  623.     //+---------------------------------------------------------------------------------
  624.     
  625.     function delete_form() {
  626.         global $IN, $root_path, $INFO, $DB, $SKIN, $ADMIN, $std, $MEMBER, $GROUP;
  627.         
  628.         $ADMIN->page_title = "Member Account Deletion";
  629.         
  630.         $ADMIN->page_detail = "Search for a member to delete by enter part or all of the username, or configure the prune form.";
  631.         
  632.         
  633.         $mem_group[0] = array( '0', 'Any member group' );
  634.         
  635.         $DB->query("SELECT g_id, g_title FROM ibf_groups ORDER BY g_title");
  636.         
  637.         while ( $r = $DB->fetch_row() )
  638.         {
  639.             $mem_group[] = array( $r['g_id'] , $r['g_title'] );
  640.         }
  641.         
  642.         //+-------------------------------
  643.         
  644.         $ADMIN->html .= $SKIN->start_form( array( 1 => array( 'code'  , 'delete2' ),
  645.                                                   2 => array( 'act'   , 'mem'     ),
  646.                                          )      );
  647.         
  648.         //+-------------------------------
  649.         
  650.         $SKIN->td_header[] = array( " "  , "40%" );
  651.         $SKIN->td_header[] = array( " "  , "60%" );
  652.         
  653.         //+-------------------------------
  654.         
  655.         $ADMIN->html .= $SKIN->start_table( "Member Lookup" );
  656.         
  657.                                          
  658.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>Enter part or all of the usersname</b>" ,
  659.                                                   $SKIN->form_input( "USER_NAME" )
  660.                                          )      );
  661.                                          
  662.         $ADMIN->html .= $SKIN->end_form("Find Member Account");
  663.                                          
  664.         $ADMIN->html .= $SKIN->end_table();
  665.         
  666.         //+-------------------------------
  667.         //+-------------------------------
  668.         
  669.         $ADMIN->html .= $SKIN->start_form( array( 1 => array( 'code'  , 'prune' ),
  670.                                                   2 => array( 'act'   , 'mem'     ),
  671.                                          )      );
  672.         
  673.         //+-------------------------------
  674.         
  675.         $SKIN->td_header[] = array( " "  , "40%" );
  676.         $SKIN->td_header[] = array( " "  , "60%" );
  677.         
  678.         //+-------------------------------
  679.         
  680.         $ADMIN->html .= $SKIN->start_table( "<u>or</u> remove members where..." );
  681.         
  682.                                          
  683.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>The members last post was over [x] days ago.</b><br>([x] = number entered)<br>(Leave blank to omit from query)" ,
  684.                                                   $SKIN->form_input( "last_post", '60')
  685.                                          )      );
  686.         
  687.         $ADMIN->html .= $SKIN->add_td_row( array( "<b><u>and</u> where the member has less than [x] posts</b><br>([x] = number entered)<br>(Leave blank to omit from query)" ,
  688.                                                   $SKIN->form_input( "posts", '100')
  689.                                          )      );
  690.                                          
  691.         $ADMIN->html .= $SKIN->add_td_row( array( "<b><u>and</u> where the member joined [x] days ago</b><br>([x] = number entered)<br>(Leave blank to omit from query)" ,
  692.                                                   $SKIN->form_input( "joined", '365')
  693.                                          )      );
  694.                                          
  695.         $ADMIN->html .= $SKIN->add_td_row( array( "<b><u>and</u> the member group is...</b>" ,
  696.                                                   $SKIN->form_dropdown( "mgroup",
  697.                                                                         $mem_group,
  698.                                                                           0
  699.                                                                         )
  700.                                          )      );
  701.                                                                           
  702.         $ADMIN->html .= $SKIN->end_form("Prune members");
  703.                                          
  704.         $ADMIN->html .= $SKIN->end_table();
  705.         
  706.         $ADMIN->output();
  707.         
  708.         
  709.     }
  710.     
  711.     //+---------------------------------------------------------------------------------
  712.     
  713.     function prune_confirm() {
  714.         global $IN, $root_path, $INFO, $DB, $SKIN, $ADMIN, $std, $MEMBER, $GROUP;
  715.         
  716.         //-----------------------------
  717.         // Make sure we have *something*
  718.         //------------------------------
  719.         
  720.         $blanks = 0;
  721.         
  722.         foreach( array( 'posts', 'last_post', 'joined' ) as $field )
  723.         {
  724.             if ($IN[ $field ] == "")
  725.             {
  726.                 $blanks++;
  727.             }
  728.         }
  729.         
  730.         if ($blanks == 3)
  731.         {
  732.             $ADMIN->error("You must specify at least one field to use in the pruning query");
  733.         }
  734.         
  735.         $time_now = time();
  736.         
  737.         $query = "SELECT COUNT(id) as mcount FROM ibf_members WHERE";
  738.         
  739.         $add_query = array();
  740.         
  741.         if ($IN['joined'] > 0)
  742.         {
  743.             $j = $time_now - ($IN['joined'] *60*60*24);
  744.             $add_query[] = " joined < $j ";
  745.         }
  746.         
  747.         if ($IN['last_post'] > 0)
  748.         {
  749.             $l = $time_now - ($IN['last_post'] *60*60*24);
  750.             $add_query[] = " last_post < $l ";
  751.         }
  752.         
  753.         if ($IN['posts'] > 0)
  754.         {
  755.             $add_query[] = " posts < ".$IN['posts']." ";
  756.         }
  757.         
  758.         if ($IN['mgroup'] > 0)
  759.         {
  760.             $add_query[] = " mgroup='".$IN['mgroup']."' ";
  761.         }
  762.         
  763.         $add_query[] = ' id > 0';
  764.         
  765.         $additional_query = implode( "AND", $add_query );
  766.         
  767.         $this_query = trim( $query.$additional_query );
  768.         
  769.         $pass_query = addslashes(urlencode($additional_query));
  770.         
  771.         //--------------------------------
  772.         // Run the query
  773.         //--------------------------------
  774.         
  775.         $DB->query($this_query);
  776.         
  777.         $count = $DB->fetch_row();
  778.         
  779.         if ($count['mcount'] < 1)
  780.         {
  781.             $ADMIN->error("We did not find any members matching the prune criteria. Please go back and try again");
  782.         }
  783.         
  784.         $ADMIN->page_title = "Member Pruning";
  785.         
  786.         $ADMIN->page_detail = "Please confirm your action.";
  787.         
  788.         //+-------------------------------
  789.         
  790.         $ADMIN->html .= $SKIN->start_form( array( 1 => array( 'code'  , 'doprune' ),
  791.                                                   2 => array( 'act'   , 'mem'     ),
  792.                                                   3 => array( 'query' , $pass_query ),
  793.                                          )      );
  794.         
  795.         //+-------------------------------
  796.         
  797.         $SKIN->td_header[] = array( " "  , "40%" );
  798.         $SKIN->td_header[] = array( " "  , "60%" );
  799.         
  800.         //+-------------------------------
  801.         
  802.         $ADMIN->html .= $SKIN->start_table( "Member Prune Confirmation" );
  803.         
  804.                                          
  805.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>Number of members to prune</b>" ,
  806.                                                   $count['mcount']
  807.                                          )      );
  808.                                          
  809.         $ADMIN->html .= $SKIN->end_form("Complete Member Pruning");
  810.                                          
  811.         $ADMIN->html .= $SKIN->end_table();
  812.         
  813.         $ADMIN->output();
  814.         
  815.     }
  816.     
  817.     
  818.     //+---------------------------------------------------------------------------------
  819.     
  820.     
  821.     function doprune() {
  822.         global $IN, $root_path, $INFO, $DB, $SKIN, $ADMIN, $std, $MEMBER, $GROUP;
  823.         
  824.         //-----------------------------
  825.         // Make sure we have *something*
  826.         //------------------------------
  827.         
  828.         $query = trim(urldecode(stripslashes($IN['query'])));
  829.         
  830.         if ($query == "")
  831.         {
  832.             $ADMIN->error("Prune query error, no query to use");
  833.         }
  834.         
  835.         //-----------------------------
  836.         // Get the member ids...
  837.         //------------------------------
  838.         
  839.         $ids = array();
  840.         
  841.         $DB->query("SELECT id FROM ibf_members WHERE ".$query);
  842.         
  843.         if ( $DB->get_num_rows() )
  844.         {
  845.             while ($i = $DB->fetch_row())
  846.             {
  847.                 $ids[] = $i['id'];
  848.             }
  849.         }
  850.         else
  851.         {
  852.             $ADMIN->error("Could not find any members that matched the prune criteria");
  853.         }
  854.         
  855.         $id_string = implode( "," , $ids );
  856.         
  857.         $id_count = count($ids);
  858.         
  859.         // Convert their posts and topics into guest postings..
  860.         
  861.         $DB->query("UPDATE ibf_posts SET author_id='0' WHERE author_id IN(".$id_string.")");
  862.         
  863.         $DB->query("UPDATE ibf_topics SET starter_id='0' WHERE starter_id IN(".$id_string.")");
  864.         
  865.         // Delete member...
  866.         
  867.         $DB->query("DELETE from ibf_members WHERE id IN(".$id_string.")");
  868.         
  869.         // Delete member messages...
  870.         
  871.         $DB->query("DELETE from ibf_messages WHERE member_id IN (".$id_string.")");
  872.         
  873.         // Delete member subscriptions.
  874.         
  875.         $DB->query("DELETE from ibf_tracker WHERE member_id IN (".$id_string.")");
  876.         
  877.         // Set the stats DB straight.
  878.         
  879.         $DB->query("SELECT id, name FROM ibf_members WHERE mgroup <> '".$INFO['auth_group']."' ORDER BY joined DESC LIMIT 0,1");
  880.         
  881.         $mem = $DB->fetch_row();
  882.         
  883.         $DB->query("UPDATE ibf_stats SET ".
  884.                          "MEM_COUNT=MEM_COUNT-".$id_count.", ".
  885.                          "LAST_MEM_NAME='" . $mem['name'] . "', ".
  886.                          "LAST_MEM_ID='"   . $mem['id']   . "'");
  887.         
  888.         // Blow me melon farmer
  889.         
  890.         $ADMIN->done_screen("Member Account(s) Deleted", "Member Control", "act=mem&code=edit" );
  891.         
  892.     }
  893.     
  894.     //+---------------------------------------------------------------------------------
  895.     
  896.     function delete_lookup_form() {
  897.         global $IN, $root_path, $INFO, $DB, $SKIN, $ADMIN, $std, $MEMBER, $GROUP;
  898.         
  899.         if ($IN['USER_NAME'] == "")
  900.         {
  901.             $ADMIN->error("You didn't choose a member name to look for!");
  902.         }
  903.         
  904.         $DB->query("SELECT id, name FROM ibf_members WHERE name LIKE '".$IN['USER_NAME']."%'");
  905.         
  906.         if (! $DB->get_num_rows() )
  907.         {
  908.             $ADMIN->error("Sorry, we could not find any members that matched the search string you entered");
  909.         }
  910.         
  911.         $form_array = array();
  912.         
  913.         while ( $r = $DB->fetch_row() )
  914.         {
  915.             $form_array[] = array( $r['id'] , $r['name'] );
  916.         }
  917.         
  918.         
  919.         
  920.         $ADMIN->page_title = "Delete a member";
  921.         
  922.         $ADMIN->page_detail = "Please choose which member to delete.";
  923.         
  924.         //+-------------------------------
  925.         
  926.         $ADMIN->html .= $SKIN->start_form( array( 1 => array( 'code'  , 'dodelete' ),
  927.                                                   2 => array( 'act'   , 'mem'     ),
  928.                                          )      );
  929.         
  930.         //+-------------------------------
  931.         
  932.         $SKIN->td_header[] = array( " "  , "40%" );
  933.         $SKIN->td_header[] = array( " "  , "60%" );
  934.         
  935.         //+-------------------------------
  936.         
  937.         $ADMIN->html .= $SKIN->start_table( "Member Lookup results" );
  938.         
  939.                                          
  940.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>Choose from the matches...</b>" ,
  941.                                                   $SKIN->form_dropdown( "MEMBER_ID", $form_array )
  942.                                          )      );
  943.                                          
  944.         $ADMIN->html .= $SKIN->end_form("Delete Member");
  945.                                          
  946.         $ADMIN->html .= $SKIN->end_table();
  947.         
  948.         $ADMIN->output();
  949.     }
  950.     
  951.     //+---------------------------------------------------------------------------------
  952.     
  953.     //+---------------------------------------------------------------------------------
  954.     //
  955.     // DO DELETE
  956.     //
  957.     //+---------------------------------------------------------------------------------
  958.     
  959.     function dodelete() {
  960.         global $IN, $root_path, $INFO, $DB, $SKIN, $ADMIN, $std, $MEMBER, $GROUP;
  961.         
  962.         if ($IN['MEMBER_ID'] == "")
  963.         {
  964.             $ADMIN->error("Could not resolve member id");
  965.         }
  966.         
  967.         //+-------------------------------
  968.         
  969.         $DB->query("SELECT * FROM ibf_members WHERE id='".$IN['MEMBER_ID']."'");
  970.         $mem = $DB->fetch_row();
  971.         
  972.         //+-------------------------------
  973.         
  974.         if ($mem['id'] == "")
  975.         {
  976.             $ADMIN->error("Could not resolve member id");
  977.         }
  978.         
  979.         // Convert their posts and topics into guest postings..
  980.         
  981.         $DB->query("UPDATE ibf_posts SET author_id='0' WHERE author_id='".$IN['MEMBER_ID']."'");
  982.         
  983.         $DB->query("UPDATE ibf_topics SET starter_id='0' WHERE starter_id='".$IN['MEMBER_ID']."'");
  984.         
  985.         // Delete member...
  986.         
  987.         $DB->query("DELETE from ibf_members WHERE id='".$IN['MEMBER_ID']."'");
  988.         
  989.         // Delete member messages...
  990.         
  991.         $DB->query("DELETE from ibf_messages WHERE member_id='".$IN['MEMBER_ID']."'");
  992.         
  993.         // Delete member subscriptions.
  994.         
  995.         $DB->query("DELETE from ibf_tracker WHERE member_id='".$IN['MEMBER_ID']."'");
  996.         
  997.         // Set the stats DB straight.
  998.         
  999.         $DB->query("SELECT id, name FROM ibf_members WHERE mgroup <> '".$INFO['auth_group']."' ORDER BY joined DESC LIMIT 0,1");
  1000.         
  1001.         $mem = $DB->fetch_row();
  1002.         
  1003.         $DB->query("UPDATE ibf_stats SET ".
  1004.                          "MEM_COUNT=MEM_COUNT-1, ".
  1005.                          "LAST_MEM_NAME='" . $mem['name'] . "', ".
  1006.                          "LAST_MEM_ID='"   . $mem['id']   . "'");
  1007.         
  1008.         // Blow me melon farmer
  1009.         
  1010.         $ADMIN->done_screen("Member Account Deleted", "Member Control", "act=mem&code=edit" );
  1011.         
  1012.     }
  1013.         
  1014.     //+-------------------------------
  1015.     //+---------------------------------------------------------------------------------
  1016.     //
  1017.     // ADD MEMBER FORM
  1018.     //
  1019.     //+---------------------------------------------------------------------------------
  1020.     
  1021.     function add_form() {
  1022.         global $IN, $root_path, $INFO, $DB, $SKIN, $ADMIN, $std, $MEMBER, $GROUP;
  1023.         
  1024.         $ADMIN->page_title = "Pre Register a member";
  1025.         
  1026.         $ADMIN->page_detail = "You may pre-register members using this form.";
  1027.         
  1028.         $DB->query("SELECT g_id, g_title FROM ibf_groups ORDER BY g_title");
  1029.         
  1030.         while ( $r = $DB->fetch_row() )
  1031.         {
  1032.             $mem_group[] = array( $r['g_id'] , $r['g_title'] );
  1033.         }
  1034.         
  1035.         //+-------------------------------
  1036.         
  1037.         $ADMIN->html .= $SKIN->start_form( array( 1 => array( 'code'  , 'doadd' ),
  1038.                                                   2 => array( 'act'   , 'mem'     ),
  1039.                                          )      );
  1040.         
  1041.         //+-------------------------------
  1042.         
  1043.         $SKIN->td_header[] = array( " "  , "40%" );
  1044.         $SKIN->td_header[] = array( " "  , "60%" );
  1045.         
  1046.         //+-------------------------------
  1047.         
  1048.         $ADMIN->html .= $SKIN->start_table( "Member Registration" );
  1049.         
  1050.                                          
  1051.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>Member Name</b>" ,
  1052.                                                   $SKIN->form_input( "name" )
  1053.                                          )      );
  1054.         
  1055.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>Password</b>" ,
  1056.                                                   $SKIN->form_input( "password", "", 'password' )
  1057.                                          )      );
  1058.                                          
  1059.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>Email Address</b>" ,
  1060.                                                   $SKIN->form_input( "email" )
  1061.                                          )      );
  1062.                                          
  1063.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>Member Group</b>" ,
  1064.                                                   $SKIN->form_dropdown( "mgroup",
  1065.                                                                         $mem_group,
  1066.                                                                           $mem['mgroup']
  1067.                                                                         )
  1068.                                          )      );
  1069.                                                                       
  1070.         $ADMIN->html .= $SKIN->end_form("Register Member");
  1071.                                          
  1072.         $ADMIN->html .= $SKIN->end_table();
  1073.         
  1074.         $ADMIN->output();
  1075.         
  1076.         
  1077.     }
  1078.     
  1079.     function do_add()
  1080.     {
  1081.         global $IN, $root_path, $INFO, $DB, $SKIN, $ADMIN, $std, $MEMBER, $GROUP;
  1082.         
  1083.         foreach( array('name', 'password', 'email', 'mgroup') as $field )
  1084.         {
  1085.             if ($IN[ $field ] == "")
  1086.             {
  1087.                 $ADMIN->error("You must complete the form fully!");
  1088.             }
  1089.         }
  1090.         
  1091.         //----------------------------------
  1092.         // Do we already have such a member?
  1093.         //----------------------------------
  1094.         
  1095.         $DB->query("SELECT id FROM ibf_members WHERE LOWER(name)='".$IN['name']."'");
  1096.         
  1097.         if ( $DB->get_num_rows() )
  1098.         {
  1099.             $ADMIN->error("We already have a member by that name, please select another");
  1100.         }
  1101.         
  1102.         //+--------------------------------------------
  1103.         //| Find the highest member id, and increment it
  1104.         //| auto_increment not used for guest id 0 val.
  1105.         //+--------------------------------------------
  1106.         
  1107.         $DB->query("SELECT MAX(id) as new_id FROM ibf_members");
  1108.         $r = $DB->fetch_row();
  1109.         
  1110.         $member_id = $r['new_id'] + 1;
  1111.         
  1112.         $db_string = $DB->compile_db_insert_string( array (
  1113.                                                              'id'          => $member_id,
  1114.                                                              'name'        => trim($IN['name']),
  1115.                                                              'password'    => md5(trim($IN['password'])),
  1116.                                                              'email'       => trim(strtolower($IN['email'])),
  1117.                                                              'mgroup'      => $IN['mgroup'],
  1118.                                                              'joined'      => time(),
  1119.                                                              'posts'       => 0,
  1120.                                                              'ip_address'  => $IN['ip_address'],
  1121.                                                              'time_offset' => 0,
  1122.                                                              'view_sigs'   => 1,
  1123.                                                              'view_avs'    => 1,
  1124.                                                              'allow_post'  => 1,
  1125.                                                              'view_pop'    => 1,
  1126.                                                              'view_img'    => 1,
  1127.                                                              'vdirs'       => "in:Inbox|sent:Sent Items",
  1128.                                                   )       );
  1129.                                                   
  1130.         $DB->query("INSERT INTO ibf_members (" .$db_string['FIELD_NAMES']. ") VALUES (". $db_string['FIELD_VALUES'] .")");
  1131.         
  1132.         $member_id = $DB->get_insert_id();
  1133.         
  1134.         $DB->query("UPDATE ibf_stats SET ".
  1135.                          "MEM_COUNT=MEM_COUNT+1, ".
  1136.                          "LAST_MEM_NAME='" . trim($IN['name']) . "', ".
  1137.                          "LAST_MEM_ID='"   . $member_id   . "'");
  1138.         
  1139.         $ADMIN->done_screen("Member Account Created", "Member Control", "act=mem&code=edit" );                                                 
  1140.         
  1141.     }
  1142.     
  1143.     
  1144.     //+---------------------------------------------------------------------------------
  1145.     //
  1146.     // SEARCH FORM, SEARCH FOR MEMBER
  1147.     //
  1148.     //+---------------------------------------------------------------------------------
  1149.     
  1150.     function search_form() {
  1151.         global $IN, $root_path, $INFO, $DB, $SKIN, $ADMIN, $std, $MEMBER, $GROUP;
  1152.         
  1153.         $ADMIN->page_title = "Edit a member";
  1154.         
  1155.         $ADMIN->page_detail = "Search for a member.";
  1156.         
  1157.         //+-------------------------------
  1158.         
  1159.         $ADMIN->html .= $SKIN->start_form( array( 1 => array( 'code'  , 'stepone' ),
  1160.                                                   2 => array( 'act'   , 'mem'     ),
  1161.                                          )      );
  1162.         
  1163.         //+-------------------------------
  1164.         
  1165.         $SKIN->td_header[] = array( " "  , "40%" );
  1166.         $SKIN->td_header[] = array( " "  , "60%" );
  1167.         
  1168.         //+-------------------------------
  1169.         
  1170.         $ADMIN->html .= $SKIN->start_table( "Search for a member" );
  1171.         
  1172.                                          
  1173.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>Enter part or all of the usersname</b>" ,
  1174.                                                   $SKIN->form_input( "USER_NAME" )
  1175.                                          )      );
  1176.                                          
  1177.         $ADMIN->html .= $SKIN->end_form("Find Member");
  1178.                                          
  1179.         $ADMIN->html .= $SKIN->end_table();
  1180.         
  1181.         $ADMIN->output();
  1182.         
  1183.         
  1184.     }
  1185.     
  1186.     //+---------------------------------------------------------------------------------
  1187.     
  1188.     function step_one() {
  1189.         global $IN, $root_path, $INFO, $DB, $SKIN, $ADMIN, $std, $MEMBER, $GROUP;
  1190.         
  1191.         if ($IN['USER_NAME'] == "")
  1192.         {
  1193.             $ADMIN->error("You didn't choose a member name to look for!");
  1194.         }
  1195.         
  1196.         $DB->query("SELECT id, name FROM ibf_members WHERE name LIKE '".$IN['USER_NAME']."%'");
  1197.         
  1198.         if (! $DB->get_num_rows() )
  1199.         {
  1200.             $ADMIN->error("Sorry, we could not find any members that matched the search string you entered");
  1201.         }
  1202.         
  1203.         $form_array = array();
  1204.         
  1205.         while ( $r = $DB->fetch_row() )
  1206.         {
  1207.             $form_array[] = array( $r['id'] , $r['name'] );
  1208.         }
  1209.         
  1210.         
  1211.         
  1212.         $ADMIN->page_title = "Edit a member";
  1213.         
  1214.         $ADMIN->page_detail = "Search for a member.";
  1215.         
  1216.         //+-------------------------------
  1217.         
  1218.         $ADMIN->html .= $SKIN->start_form( array( 1 => array( 'code'  , 'doform' ),
  1219.                                                   2 => array( 'act'   , 'mem'     ),
  1220.                                          )      );
  1221.         
  1222.         //+-------------------------------
  1223.         
  1224.         $SKIN->td_header[] = array( " "  , "40%" );
  1225.         $SKIN->td_header[] = array( " "  , "60%" );
  1226.         
  1227.         //+-------------------------------
  1228.         
  1229.         $ADMIN->html .= $SKIN->start_table( "Search for a member" );
  1230.         
  1231.                                          
  1232.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>Choose from the matches...</b>" ,
  1233.                                                   $SKIN->form_dropdown( "MEMBER_ID", $form_array )
  1234.                                          )      );
  1235.                                          
  1236.         $ADMIN->html .= $SKIN->end_form("Edit Member");
  1237.                                          
  1238.         $ADMIN->html .= $SKIN->end_table();
  1239.         
  1240.         $ADMIN->output();
  1241.         
  1242.         
  1243.         
  1244.         
  1245.         
  1246.     }
  1247.     
  1248.     
  1249.     //+---------------------------------------------------------------------------------
  1250.     //
  1251.     // DO EDIT FORM
  1252.     //
  1253.     //+---------------------------------------------------------------------------------
  1254.     
  1255.     function do_edit_form() {
  1256.         global $IN, $root_path, $INFO, $DB, $SKIN, $ADMIN, $std, $MEMBER, $GROUP, $ibforums;
  1257.         
  1258.         require $root_path."sources/lib/post_parser.php";
  1259.         
  1260.         $parser = new post_parser();
  1261.         
  1262.         if ($IN['MEMBER_ID'] == "")
  1263.         {
  1264.             $ADMIN->error("Could not resolve member id");
  1265.         }
  1266.         
  1267.         //+-------------------------------
  1268.         
  1269.         $DB->query("SELECT * FROM ibf_members WHERE id='".$IN['MEMBER_ID']."'");
  1270.         $mem = $DB->fetch_row();
  1271.         
  1272.         //+-------------------------------
  1273.         
  1274.         if ($mem['id'] == "")
  1275.         {
  1276.             $ADMIN->error("Could not resolve member id");
  1277.         }
  1278.         
  1279.         //+-------------------------------
  1280.         
  1281.         $mem_group = array();
  1282.         
  1283.         $DB->query("SELECT g_id, g_title FROM ibf_groups ORDER BY g_title");
  1284.         
  1285.         while ( $r = $DB->fetch_row() )
  1286.         {
  1287.             $mem_group[] = array( $r['g_id'] , $r['g_title'] );
  1288.         }
  1289.         
  1290.         //+-------------------------------
  1291.         
  1292.         $lang_array = array();
  1293.         
  1294.         $DB->query("SELECT ldir, lname FROM ibf_languages");
  1295.         
  1296.         while ( $l = $DB->fetch_row() )
  1297.         {
  1298.             $lang_array[] = array( $l['ldir'], $l['lname'] );
  1299.         }
  1300.          
  1301.          //+-------------------------------
  1302.          
  1303.          $DB->query("SELECT uid, sid, sname FROM ibf_skins");
  1304.          
  1305.          $skin_array = array();
  1306.              
  1307.         if ( $DB->get_num_rows() )
  1308.         {
  1309.             while ( $s = $DB->fetch_row() )
  1310.             {
  1311.                 
  1312.                 $skin_array[] = array( $s['sid'], $s['sname'] );
  1313.                
  1314.             }
  1315.         }
  1316.             
  1317.         //+-------------------------------
  1318.         //+-------------------------------
  1319.         
  1320.         
  1321.         $ADMIN->page_title = "Edit member: ".$mem['name']." (ID: ".$mem['id'].")";
  1322.         
  1323.         $ADMIN->page_detail = "You may alter the members settings from here.";
  1324.         
  1325.         //+-------------------------------
  1326.         
  1327.         $ADMIN->html .= $SKIN->start_form( array( 1 => array( 'code'  , 'doedit'  ),
  1328.                                                   2 => array( 'act'   , 'mem'     ),
  1329.                                                   3 => array( 'mid'   , $mem['id'] ),
  1330.                                                   4 => array( 'curpass', $mem['password'] ),
  1331.                                             ) );
  1332.         
  1333.         //+-------------------------------
  1334.         
  1335.         $SKIN->td_header[] = array( " "  , "40%" );
  1336.         $SKIN->td_header[] = array( " "  , "60%" );
  1337.         
  1338.         //+-------------------------------
  1339.         
  1340.         $ADMIN->html .= $SKIN->start_table( "Member Security Settings" );
  1341.         
  1342.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>Allow {$mem['name']} to post where allowed?</b>" ,
  1343.                                                   $SKIN->form_yes_no("allow_post", $mem['allow_post'] )
  1344.                                          )      );
  1345.                                          
  1346.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>Member Group</b>" ,
  1347.                                                   $SKIN->form_dropdown( "mgroup",
  1348.                                                                         $mem_group,
  1349.                                                                           $mem['mgroup']
  1350.                                                                         )
  1351.                                          )      );
  1352.                                          
  1353.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>Member Title</b>" ,
  1354.                                                   $SKIN->form_input("title", $mem['title'])
  1355.                                          )      );
  1356.                                          
  1357.         $ADMIN->html .= $SKIN->end_table();
  1358.         
  1359.         //+-------------------------------
  1360.         
  1361.         $SKIN->td_header[] = array( " "  , "40%" );
  1362.         $SKIN->td_header[] = array( " "  , "60%" );
  1363.         
  1364.         //+-------------------------------
  1365.         
  1366.         $ADMIN->html .= $SKIN->start_table( "Password Control" );
  1367.         
  1368.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>New Password</b><br>(Leave this blank if you do not wish to reset password!)" ,
  1369.                                                   $SKIN->form_input("password")
  1370.                                          )      );
  1371.                                          
  1372.         $ADMIN->html .= $SKIN->end_table();
  1373.         
  1374.         //+-------------------------------+
  1375.         
  1376.         $SKIN->td_header[] = array( " "  , "40%" );
  1377.         $SKIN->td_header[] = array( " "  , "60%" );
  1378.         
  1379.         //+-------------------------------+
  1380.         
  1381.         $ADMIN->html .= $SKIN->start_table( "Board Settings" );                                 
  1382.         
  1383.         //+-------------------------------
  1384.         
  1385.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>Language Choice</b>" ,
  1386.                                                   $SKIN->form_dropdown( "language",
  1387.                                                                         $lang_array,
  1388.                                                                           $mem['language']
  1389.                                                                         )
  1390.                                          )      );
  1391.                                          
  1392.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>Skin Choice</b>" ,
  1393.                                                   $SKIN->form_dropdown( "skin",
  1394.                                                                         $skin_array,
  1395.                                                                           $mem['skin']
  1396.                                                                         )
  1397.                                          )      );
  1398.                                          
  1399.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>Hide this members email address?</b>" ,
  1400.                                                   $SKIN->form_yes_no("hide_email", $mem['hide_email'] )
  1401.                                          )      );
  1402.                                                                       
  1403.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>Email a PM reminder?</b>" ,
  1404.                                                   $SKIN->form_yes_no("email_pm", $mem['email_pm'] )
  1405.                                          )      );        
  1406.         
  1407.         $ADMIN->html .= $SKIN->end_table();
  1408.         
  1409.         //+-------------------------------+
  1410.         
  1411.         $SKIN->td_header[] = array( " "  , "40%" );
  1412.         $SKIN->td_header[] = array( " "  , "60%" );
  1413.         
  1414.         //+-------------------------------+
  1415.         
  1416.         $ADMIN->html .= $SKIN->start_table( "Contact Information" );
  1417.         
  1418.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>Email Address</b>" ,
  1419.                                                   $SKIN->form_input("email", $mem['email'])
  1420.                                          )      );
  1421.                                          
  1422.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>AIM Identity</b>" ,
  1423.                                                   $SKIN->form_input("aim_name", $mem['aim_name'])
  1424.                                          )      );                                                              
  1425.         
  1426.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>ICQ Number</b>" ,
  1427.                                                   $SKIN->form_input("icq_number", $mem['icq_number'])
  1428.                                          )      );
  1429.                                          
  1430.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>Yahoo Identity</b>" ,
  1431.                                                   $SKIN->form_input("yahoo", $mem['yahoo'])
  1432.                                          )      );
  1433.         
  1434.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>MSN Identity</b>" ,
  1435.                                                   $SKIN->form_input("msnname", $mem['msnname'])
  1436.                                          )      );
  1437.                                          
  1438.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>Website Address</b>" ,
  1439.                                                   $SKIN->form_input("website", $mem['website'])
  1440.                                          )      );
  1441.                                          
  1442.         $ADMIN->html .= $SKIN->end_table();
  1443.         
  1444.         //+-------------------------------+
  1445.         
  1446.         $SKIN->td_header[] = array( " "  , "40%" );
  1447.         $SKIN->td_header[] = array( " "  , "60%" );
  1448.         
  1449.         //+-------------------------------+
  1450.         
  1451.         $ADMIN->html .= $SKIN->start_table( "Other Information" );
  1452.                                                                                                            
  1453.         //+-------------------------------
  1454.         
  1455.         $mem['signature'] = $parser->unconvert( $mem['signature'] );
  1456.         
  1457.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>Avatar</b>" ,
  1458.                                                   $SKIN->form_input("avatar", $mem['avatar'])
  1459.                                          )      );
  1460.                                          
  1461.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>Avatar Size</b>" ,
  1462.                                                   $SKIN->form_input("avatar_size", $mem['avatar_size'])
  1463.                                          )      );
  1464.                                          
  1465.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>Photo URL</b>" ,
  1466.                                                   $SKIN->form_input("photo", $mem['photo'])
  1467.                                          )      );
  1468.                                          
  1469.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>Post Count</b>" ,
  1470.                                                   $SKIN->form_input("posts", $mem['posts'])
  1471.                                          )      );
  1472.                                          
  1473.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>Location</b>" ,
  1474.                                                   $SKIN->form_input("location", $mem['location'])
  1475.                                          )      );
  1476.                                          
  1477.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>Interests</b>" ,
  1478.                                                   $SKIN->form_textarea("interests", $mem['interests'])
  1479.                                          )      );
  1480.         
  1481.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>Signature</b>" ,
  1482.                                                   $SKIN->form_textarea("signature", $mem['signature'])
  1483.                                          )      );
  1484.         
  1485.         $ADMIN->html .= $SKIN->end_table();
  1486.         
  1487.         //+-------------------------------+
  1488.         
  1489.         $SKIN->td_header[] = array( " "  , "40%" );
  1490.         $SKIN->td_header[] = array( " "  , "60%" );
  1491.         
  1492.         //+-------------------------------+
  1493.         
  1494.         $ADMIN->html .= $SKIN->start_table( "Validation Keys" );
  1495.         
  1496.         
  1497.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>Validation Key</b><br>(Do not alter unless you are sure it is no longer needed!)" ,
  1498.                                                   $SKIN->form_input("validate_key", $mem['validate_key'])
  1499.                                          )      );
  1500.                                          
  1501.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>New Password (MD5)</b><br>(Do not alter unless you are sure it is no longer needed!)" ,
  1502.                                                   $SKIN->form_input("new_pass", $mem['new_pass'])
  1503.                                          )      );
  1504.                                          
  1505.         $ADMIN->html .= $SKIN->add_td_row( array( "<b>Previous Member Group ID</b><br>(Do not alter unless you are sure it is no longer needed!)" ,
  1506.                                                   $SKIN->form_input("prev_group", $mem['prev_group'])
  1507.                                          )      );
  1508.                                                                                                                                             
  1509.         //+-------------------------------
  1510.                                                                                                                                             
  1511.         $ADMIN->html .= $SKIN->end_form("Edit this member");
  1512.                                          
  1513.         $ADMIN->html .= $SKIN->end_table();
  1514.         
  1515.         $ADMIN->output();
  1516.             
  1517.             
  1518.     }
  1519.  
  1520.  
  1521.     //+---------------------------------------------------------------------------------
  1522.     
  1523.     function do_edit() {
  1524.         global $IN, $root_path, $INFO, $DB, $SKIN, $ADMIN, $std, $MEMBER, $GROUP, $ibforums;
  1525.         
  1526.         $password = "";
  1527.         
  1528.         if ($IN['password'] != "")
  1529.         {
  1530.             $password = ", password='".md5($IN['password'])."'";
  1531.         }
  1532.         
  1533.         require $root_path."sources/lib/post_parser.php";
  1534.         
  1535.         $parser = new post_parser();
  1536.         
  1537.         $IN['signature'] = $parser->convert( array ('TEXT'      => $IN['signature'],
  1538.                                                     'SMILIES'   => 0,
  1539.                                                     'CODE'      => $INFO['sig_allow_ibc'],
  1540.                                                     'HTML'      => $INFO['sig_allow_html'],
  1541.                                                     'SIGNATURE' => 1
  1542.                                            )       );
  1543.         
  1544.         $db_string = $DB->compile_db_update_string( array (
  1545.                                                             'allow_post'   => $IN['allow_post'],
  1546.                                                             'mgroup'       => $IN['mgroup'],
  1547.                                                             'title'        => $IN['title'],
  1548.                                                             'validate_key' => $IN['validate_key'],
  1549.                                                             'new_pass'     => $IN['new_pass'],
  1550.                                                             'prev_group'   => $IN['prev_group'],
  1551.                                                             'language'     => $IN['language'],
  1552.                                                             'skin'         => $IN['skin'],
  1553.                                                             'hide_email'   => $IN['hide_email'],
  1554.                                                             'email_pm'     => $IN['email_pm'],
  1555.                                                             'email'        => $IN['email'],
  1556.                                                             'aim_name'     => $IN['aim_name'],
  1557.                                                             'icq_number'   => $IN['icq_number'],
  1558.                                                             'yahoo'        => $IN['yahoo'],
  1559.                                                             'msnname'      => $IN['msnname'],
  1560.                                                             'website'      => $IN['website'],
  1561.                                                             'avatar'       => $IN['avatar'],
  1562.                                                             'avatar_size'  => $IN['avatar_size'],
  1563.                                                             'photo'        => $IN['photo'],
  1564.                                                             'posts'        => $IN['posts'],
  1565.                                                             'location'     => $IN['location'],
  1566.                                                             'interests'    => $IN['interests'],
  1567.                                                             'signature'    => $IN['signature'],
  1568.                                                   )       );
  1569.                                                   
  1570.         $DB->query("UPDATE ibf_members SET $db_string".$password." WHERE id='".$IN['mid']."'");
  1571.         
  1572.         $ADMIN->done_screen("Member Edited", "Member Control", "act=mem&code=edit" );
  1573.         
  1574.     }
  1575.  
  1576.  
  1577.     
  1578.     
  1579.         
  1580. }
  1581.  
  1582.  
  1583. ?>